/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package converter.core.db.entity;

import java.io.Serializable;
import java.math.BigInteger;
import java.util.Date;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

/**
 *
 * @author Snark
 */
@Entity
@Table(name = "SYS_TABLES")
@NamedQueries({
    @NamedQuery(name = "SysTables.findAll", query = "SELECT s FROM SysTables s"),
    @NamedQuery(name = "SysTables.findBySysFldorder", query = "SELECT s FROM SysTables s WHERE s.sysFldorder = :sysFldorder"),
    @NamedQuery(name = "SysTables.findBySysGuid", query = "SELECT s FROM SysTables s WHERE s.sysGuid = :sysGuid"),
    @NamedQuery(name = "SysTables.findBySysState", query = "SELECT s FROM SysTables s WHERE s.sysState = :sysState"),
    @NamedQuery(name = "SysTables.findBySysRev", query = "SELECT s FROM SysTables s WHERE s.sysRev = :sysRev"),
    @NamedQuery(name = "SysTables.findBySysCreated", query = "SELECT s FROM SysTables s WHERE s.sysCreated = :sysCreated"),
    @NamedQuery(name = "SysTables.findBySysUpdated", query = "SELECT s FROM SysTables s WHERE s.sysUpdated = :sysUpdated"),
    @NamedQuery(name = "SysTables.findBySysCreator", query = "SELECT s FROM SysTables s WHERE s.sysCreator = :sysCreator"),
    @NamedQuery(name = "SysTables.findBySysUser", query = "SELECT s FROM SysTables s WHERE s.sysUser = :sysUser"),
    @NamedQuery(name = "SysTables.findBySysGuidfk", query = "SELECT s FROM SysTables s WHERE s.sysGuidfk = :sysGuidfk"),
    @NamedQuery(name = "SysTables.findBySysParentguid", query = "SELECT s FROM SysTables s WHERE s.sysParentguid = :sysParentguid"),
    @NamedQuery(name = "SysTables.findByName", query = "SELECT s FROM SysTables s WHERE s.name = :name"),
    @NamedQuery(name = "SysTables.findByAlias", query = "SELECT s FROM SysTables s WHERE s.alias = :alias"),
    @NamedQuery(name = "SysTables.findByDescription", query = "SELECT s FROM SysTables s WHERE s.description = :description"),
    @NamedQuery(name = "SysTables.findByIstree", query = "SELECT s FROM SysTables s WHERE s.istree = :istree"),
    @NamedQuery(name = "SysTables.findByIsdir", query = "SELECT s FROM SysTables s WHERE s.isdir = :isdir"),
    @NamedQuery(name = "SysTables.findByOrder", query = "SELECT s FROM SysTables s WHERE s.order = :order"),
    @NamedQuery(name = "SysTables.findByFieldid", query = "SELECT s FROM SysTables s WHERE s.fieldid = :fieldid"),
    @NamedQuery(name = "SysTables.findByFieldfk", query = "SELECT s FROM SysTables s WHERE s.fieldfk = :fieldfk"),
    @NamedQuery(name = "SysTables.findByInfofield", query = "SELECT s FROM SysTables s WHERE s.infofield = :infofield"),
    @NamedQuery(name = "SysTables.findByMultiselection", query = "SELECT s FROM SysTables s WHERE s.multiselection = :multiselection"),
    @NamedQuery(name = "SysTables.findByMultilookupfield", query = "SELECT s FROM SysTables s WHERE s.multilookupfield = :multilookupfield"),
    @NamedQuery(name = "SysTables.findByUniq", query = "SELECT s FROM SysTables s WHERE s.uniq = :uniq"),
    @NamedQuery(name = "SysTables.findByIndexes", query = "SELECT s FROM SysTables s WHERE s.indexes = :indexes"),
    @NamedQuery(name = "SysTables.findByUniques", query = "SELECT s FROM SysTables s WHERE s.uniques = :uniques"),
    @NamedQuery(name = "SysTables.findByMultiisunique", query = "SELECT s FROM SysTables s WHERE s.multiisunique = :multiisunique"),
    @NamedQuery(name = "SysTables.findByCaneditinchooser", query = "SELECT s FROM SysTables s WHERE s.caneditinchooser = :caneditinchooser"),
    @NamedQuery(name = "SysTables.findByIsfact", query = "SELECT s FROM SysTables s WHERE s.isfact = :isfact"),
    @NamedQuery(name = "SysTables.findByIsview", query = "SELECT s FROM SysTables s WHERE s.isview = :isview"),
    @NamedQuery(name = "SysTables.findByEditablet", query = "SELECT s FROM SysTables s WHERE s.editablet = :editablet"),
    @NamedQuery(name = "SysTables.findByChknullonexp", query = "SELECT s FROM SysTables s WHERE s.chknullonexp = :chknullonexp"),
    @NamedQuery(name = "SysTables.findByDetailfield", query = "SELECT s FROM SysTables s WHERE s.detailfield = :detailfield"),
    @NamedQuery(name = "SysTables.findByDecoguid", query = "SELECT s FROM SysTables s WHERE s.decoguid = :decoguid"),
    @NamedQuery(name = "SysTables.findByOrderby", query = "SELECT s FROM SysTables s WHERE s.orderby = :orderby")})
public class SysTables implements Serializable {
    private static final long serialVersionUID = 1L;
    @Column(name = "SYS_FLDORDER")
    private Integer sysFldorder;
    @Id
    @Basic(optional = false)
    @Column(name = "SYS_GUID")
    private String sysGuid;
    @Column(name = "SYS_STATE")
    private Integer sysState;
    @Column(name = "SYS_REV")
    private BigInteger sysRev;
    @Column(name = "SYS_CREATED")
    @Temporal(TemporalType.TIMESTAMP)
    private Date sysCreated;
    @Column(name = "SYS_UPDATED")
    @Temporal(TemporalType.TIMESTAMP)
    private Date sysUpdated;
    @Column(name = "SYS_CREATOR")
    private String sysCreator;
    @Column(name = "SYS_USER")
    private String sysUser;
    @Column(name = "SYS_GUIDFK")
    private String sysGuidfk;
    @Column(name = "SYS_PARENTGUID")
    private String sysParentguid;
    @Column(name = "NAME")
    private String name;
    @Column(name = "ALIAS")
    private String alias;
    @Column(name = "DESCRIPTION")
    private String description;
    @Lob
    @Column(name = "COMMENT")
    private String comment;
    @Column(name = "ISTREE")
    private Integer istree;
    @Column(name = "ISDIR")
    private Integer isdir;
    @Column(name = "ORDER")
    private Integer order;
    @Column(name = "FIELDID")
    private String fieldid;
    @Column(name = "FIELDFK")
    private String fieldfk;
    @Column(name = "INFOFIELD")
    private String infofield;
    @Lob
    @Column(name = "FIELDSLIST")
    private String fieldslist;
    @Column(name = "MULTISELECTION")
    private Integer multiselection;
    @Column(name = "MULTILOOKUPFIELD")
    private String multilookupfield;
    @Column(name = "UNIQ")
    private String uniq;
    @Column(name = "INDEXES")
    private String indexes;
    @Column(name = "UNIQUES")
    private String uniques;
    @Column(name = "MULTIISUNIQUE")
    private Integer multiisunique;
    @Column(name = "CANEDITINCHOOSER")
    private Integer caneditinchooser;
    @Lob
    @Column(name = "MULTIFILTER")
    private String multifilter;
    @Lob
    @Column(name = "KEYGEN")
    private String keygen;
    @Column(name = "ISFACT")
    private Integer isfact;
    @Lob
    @Column(name = "YAXES")
    private String yaxes;
    @Lob
    @Column(name = "FIELDSMEASURES")
    private String fieldsmeasures;
    @Lob
    @Column(name = "XAXES")
    private String xaxes;
    @Lob
    @Column(name = "FACTS")
    private String facts;
    @Lob
    @Column(name = "FILTERFIELDS")
    private String filterfields;
    @Column(name = "ISVIEW")
    private Integer isview;
    @Lob
    @Column(name = "VIEWSQL")
    private String viewsql;
    @Column(name = "EDITABLET")
    private String editablet;
    @Column(name = "CHKNULLONEXP")
    private Integer chknullonexp;
    @Column(name = "DETAILFIELD")
    private String detailfield;
    @Column(name = "DECOGUID")
    private Integer decoguid;
    @Column(name = "ORDERBY")
    private String orderby;

    public SysTables() {
    }

    public SysTables(String sysGuid) {
        this.sysGuid = sysGuid;
    }

    public Integer getSysFldorder() {
        return sysFldorder;
    }

    public void setSysFldorder(Integer sysFldorder) {
        this.sysFldorder = sysFldorder;
    }

    public String getSysGuid() {
        return sysGuid;
    }

    public void setSysGuid(String sysGuid) {
        this.sysGuid = sysGuid;
    }

    public Integer getSysState() {
        return sysState;
    }

    public void setSysState(Integer sysState) {
        this.sysState = sysState;
    }

    public BigInteger getSysRev() {
        return sysRev;
    }

    public void setSysRev(BigInteger sysRev) {
        this.sysRev = sysRev;
    }

    public Date getSysCreated() {
        return sysCreated;
    }

    public void setSysCreated(Date sysCreated) {
        this.sysCreated = sysCreated;
    }

    public Date getSysUpdated() {
        return sysUpdated;
    }

    public void setSysUpdated(Date sysUpdated) {
        this.sysUpdated = sysUpdated;
    }

    public String getSysCreator() {
        return sysCreator;
    }

    public void setSysCreator(String sysCreator) {
        this.sysCreator = sysCreator;
    }

    public String getSysUser() {
        return sysUser;
    }

    public void setSysUser(String sysUser) {
        this.sysUser = sysUser;
    }

    public String getSysGuidfk() {
        return sysGuidfk;
    }

    public void setSysGuidfk(String sysGuidfk) {
        this.sysGuidfk = sysGuidfk;
    }

    public String getSysParentguid() {
        return sysParentguid;
    }

    public void setSysParentguid(String sysParentguid) {
        this.sysParentguid = sysParentguid;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getAlias() {
        return alias;
    }

    public void setAlias(String alias) {
        this.alias = alias;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public String getComment() {
        return comment;
    }

    public void setComment(String comment) {
        this.comment = comment;
    }

    public Integer getIstree() {
        return istree;
    }

    public void setIstree(Integer istree) {
        this.istree = istree;
    }

    public Integer getIsdir() {
        return isdir;
    }

    public void setIsdir(Integer isdir) {
        this.isdir = isdir;
    }

    public Integer getOrder() {
        return order;
    }

    public void setOrder(Integer order) {
        this.order = order;
    }

    public String getFieldid() {
        return fieldid;
    }

    public void setFieldid(String fieldid) {
        this.fieldid = fieldid;
    }

    public String getFieldfk() {
        return fieldfk;
    }

    public void setFieldfk(String fieldfk) {
        this.fieldfk = fieldfk;
    }

    public String getInfofield() {
        return infofield;
    }

    public void setInfofield(String infofield) {
        this.infofield = infofield;
    }

    public String getFieldslist() {
        return fieldslist;
    }

    public void setFieldslist(String fieldslist) {
        this.fieldslist = fieldslist;
    }

    public Integer getMultiselection() {
        return multiselection;
    }

    public void setMultiselection(Integer multiselection) {
        this.multiselection = multiselection;
    }

    public String getMultilookupfield() {
        return multilookupfield;
    }

    public void setMultilookupfield(String multilookupfield) {
        this.multilookupfield = multilookupfield;
    }

    public String getUniq() {
        return uniq;
    }

    public void setUniq(String uniq) {
        this.uniq = uniq;
    }

    public String getIndexes() {
        return indexes;
    }

    public void setIndexes(String indexes) {
        this.indexes = indexes;
    }

    public String getUniques() {
        return uniques;
    }

    public void setUniques(String uniques) {
        this.uniques = uniques;
    }

    public Integer getMultiisunique() {
        return multiisunique;
    }

    public void setMultiisunique(Integer multiisunique) {
        this.multiisunique = multiisunique;
    }

    public Integer getCaneditinchooser() {
        return caneditinchooser;
    }

    public void setCaneditinchooser(Integer caneditinchooser) {
        this.caneditinchooser = caneditinchooser;
    }

    public String getMultifilter() {
        return multifilter;
    }

    public void setMultifilter(String multifilter) {
        this.multifilter = multifilter;
    }

    public String getKeygen() {
        return keygen;
    }

    public void setKeygen(String keygen) {
        this.keygen = keygen;
    }

    public Integer getIsfact() {
        return isfact;
    }

    public void setIsfact(Integer isfact) {
        this.isfact = isfact;
    }

    public String getYaxes() {
        return yaxes;
    }

    public void setYaxes(String yaxes) {
        this.yaxes = yaxes;
    }

    public String getFieldsmeasures() {
        return fieldsmeasures;
    }

    public void setFieldsmeasures(String fieldsmeasures) {
        this.fieldsmeasures = fieldsmeasures;
    }

    public String getXaxes() {
        return xaxes;
    }

    public void setXaxes(String xaxes) {
        this.xaxes = xaxes;
    }

    public String getFacts() {
        return facts;
    }

    public void setFacts(String facts) {
        this.facts = facts;
    }

    public String getFilterfields() {
        return filterfields;
    }

    public void setFilterfields(String filterfields) {
        this.filterfields = filterfields;
    }

    public Integer getIsview() {
        return isview;
    }

    public void setIsview(Integer isview) {
        this.isview = isview;
    }

    public String getViewsql() {
        return viewsql;
    }

    public void setViewsql(String viewsql) {
        this.viewsql = viewsql;
    }

    public String getEditablet() {
        return editablet;
    }

    public void setEditablet(String editablet) {
        this.editablet = editablet;
    }

    public Integer getChknullonexp() {
        return chknullonexp;
    }

    public void setChknullonexp(Integer chknullonexp) {
        this.chknullonexp = chknullonexp;
    }

    public String getDetailfield() {
        return detailfield;
    }

    public void setDetailfield(String detailfield) {
        this.detailfield = detailfield;
    }

    public Integer getDecoguid() {
        return decoguid;
    }

    public void setDecoguid(Integer decoguid) {
        this.decoguid = decoguid;
    }

    public String getOrderby() {
        return orderby;
    }

    public void setOrderby(String orderby) {
        this.orderby = orderby;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (sysGuid != null ? sysGuid.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof SysTables)) {
            return false;
        }
        SysTables other = (SysTables) object;
        if ((this.sysGuid == null && other.sysGuid != null) || (this.sysGuid != null && !this.sysGuid.equals(other.sysGuid))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "javaapplication1.entity.SysTables[ sysGuid=" + sysGuid + " ]";
    }
    
}
